Seitdem ich das WSC auf die Version 5.2.7 aktualisiert habe, bekomme ich 1x täglich den folgenden Fehler im Log aufgelistet:
Code
Thu, 09 Jul 2020 04:25:03 +0000
Message: Could not execute statement 'SELECT notificationID, userID FROM wcf1_user_notification WHERE userID IN (?) AND eventID = ? AND eventHash = ? AND confirmTime = ?'
PHP version: 7.2.31-1+ubuntu18.04.1+deb.sury.org+1
WoltLab Suite version: 5.2.7
Request URI: /downloads/index.php?ajax-proxy/&t=da5ec2a11ca4d46835a51ccfc92b9e14da5f7f92
Referrer: https://www.compiware-forum.de/downloads/file/164-commandos-2-men-of-courage-german-patch/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0
Peak Memory Usage: 13212608/268435456
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'SELECT notificationID, userID FROM wcf1_user_notification WHERE userID IN (?) AND eventID = ? AND eventHash = ? AND confirmTime = ?'
Error Code: 0
File: /var/www/compiware-forum.de/htdocs/compiware-forum.de/lib/system/database/statement/PreparedStatement.class.php (105)
Extra Information: YTozOntpOjA7YToyOntpOjA7czoxNzoiUXVlcnkgUGFyYW1ldGVyIDEiO2k6MTtpOjExOTt9aToxO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAyIjtpOjE7czo0MjoiJzg5NmJjMGE0YmE4Mjk5OWJmZTE1ODdmZjNmZDg4MWQ3N2ExNjk4N2UnIjt9aToyO2E6Mjp7aTowO3M6MTc6IlF1ZXJ5IFBhcmFtZXRlciAzIjtpOjE7aTowO319
Stack Trace: [{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/user\/notification\/UserNotificationHandler.class.php","line":140,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]"]]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/cronjob\/FFFriendsBirthdayCronjob.class.php","line":38,"function":"fireEvent","class":"wcf\\system\\user\\notification\\UserNotificationHandler","type":"->","args":["birthday","eu.feuerfuchs.wcf.friends.birthday","wcf\\system\\user\\notification\\object\\FFUserFriendBirthdayUserNotificationObject",[]]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/cronjob\/CronjobScheduler.class.php","line":251,"function":"execute","class":"wcf\\system\\cronjob\\FFFriendsBirthdayCronjob","type":"->","args":["wcf\\data\\cronjob\\Cronjob"]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/cronjob\/CronjobScheduler.class.php","line":77,"function":"executeCronjob","class":"wcf\\system\\cronjob\\CronjobScheduler","type":"->","args":["wcf\\data\\cronjob\\CronjobEditor","wcf\\data\\cronjob\\log\\CronjobLogEditor"]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/data\/cronjob\/CronjobAction.class.php","line":232,"function":"executeCronjobs","class":"wcf\\system\\cronjob\\CronjobScheduler","type":"->","args":[]},{"function":"executeCronjobs","class":"wcf\\data\\cronjob\\CronjobAction","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"call_user_func","args":[["[redacted]","[redacted]"]],"class":"","type":""},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/downloads\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["filebase"]}]
======
Error Class: PDOException
Error Message: SQLSTATE[HY093]: Invalid parameter number
Error Code: 0
File: /var/www/compiware-forum.de/htdocs/compiware-forum.de/lib/system/database/statement/PreparedStatement.class.php (93)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]"]]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/user\/notification\/UserNotificationHandler.class.php","line":140,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[["[redacted]","[redacted]","[redacted]"]]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/cronjob\/FFFriendsBirthdayCronjob.class.php","line":38,"function":"fireEvent","class":"wcf\\system\\user\\notification\\UserNotificationHandler","type":"->","args":["birthday","eu.feuerfuchs.wcf.friends.birthday","wcf\\system\\user\\notification\\object\\FFUserFriendBirthdayUserNotificationObject",[]]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/cronjob\/CronjobScheduler.class.php","line":251,"function":"execute","class":"wcf\\system\\cronjob\\FFFriendsBirthdayCronjob","type":"->","args":["wcf\\data\\cronjob\\Cronjob"]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/cronjob\/CronjobScheduler.class.php","line":77,"function":"executeCronjob","class":"wcf\\system\\cronjob\\CronjobScheduler","type":"->","args":["wcf\\data\\cronjob\\CronjobEditor","wcf\\data\\cronjob\\log\\CronjobLogEditor"]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/data\/cronjob\/CronjobAction.class.php","line":232,"function":"executeCronjobs","class":"wcf\\system\\cronjob\\CronjobScheduler","type":"->","args":[]},{"function":"executeCronjobs","class":"wcf\\data\\cronjob\\CronjobAction","type":"->","args":[],"file":"[internal function]","line":"?"},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"call_user_func","args":[["[redacted]","[redacted]"]],"class":"","type":""},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/action\/AJAXProxyAction.class.php","line":75,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/action\/AJAXInvokeAction.class.php","line":94,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/action\/AJAXInvokeAction.class.php","line":61,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/compiware-forum.de\/htdocs\/compiware-forum.de\/downloads\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["filebase"]}]Ich habe bereits bei WoltLab im Forum angefragt, weil es seit der Version 5.2.7 ein generelles Problem mit Cronjob-Fehlermeldungen gibt. Aber dieser Fehler fällt wohl nicht darunter... 
Der Cronjob selbst läuft auch in einen Fehler:
Installiert habe ich die Version 5.2.1 des Plugins.
Laut Alexander Ebert deutet der Fehler auf folgendes hin:
Die Fehlermeldung deutet übrigens auf einen Programmierfehler hin, bei dem eine Datenbankabfrage mit einer unpassenden Anzahl an Parametern versucht wird auszuführen. Ob andere das Problem haben oder nicht, spielt absolut keine Rolle, denn es kann auch von anderen Faktoren abhängen.
Mag sich das vielleicht mal jemand anschauen, ob der Fehler vielleicht behoben werden kann?
